Councils abandon prayers following pressure from secularists