Scotland's only school dedicated to sporting excellence is facing closure, with the programme to be wound down weeks before the Commonwealth Games in the city