Top boss apologises and education secretary orders investigation after error leaves many schools with tens of thousands of pounds less than expected