Two-fifths of Scots have lost trust in the Scottish Government’s ability to improve their lives, new research has found.