Councils are spending as much as £950 a day to get a single child to school in a sign of the spiralling cost of supporting special needs pupils.