SNP government lambasted by Lib Dem, Labour and Tory MSPs over sums paid to locum emergency psychiatrists.