In some councils pupil demand is ‘vastly larger than supply’ and funding is not keeping pace with rising costs