Opinion of country has gone up since last Pew survey in 2012, but 60 per cent of respondents took a negative view of president’s handling of world affairs