Almost 1,000 school pupils have been caught with weapons including guns and knives in the past three years