Data shows sharp increase in number of children receiving extra support and highlights pressure on schools, families and councils