Most school support staff in Scotland say it has ‘become part of the job to expect violence’, hear MSPs.