Thousands of primary school pupils have been treated to live musical performances from the Royal Scottish National Orchestre.