Thousands of schoolchildren will get the chance to walk over Scotland's newest bridge the day after it is opened by the Queen.