Charities have called for urgent investment in schools after new data showed 43% of Scotland's pupils now have additional support needs, with huge variation between schools.