Majority of voters back the government’s current push to ‘reset’ relations with the EU, experts find