Nearly every council is spending thousands on high-cost emergency placements as the number of children in care continues to rise.