Confidence in the Government has soared to a six-year high, according to the latest opinion poll.