Levels of trust in the SNP government have collapsed amid growing concerns about the state of Scotland's public services.