A majority of Scots would vote to rejoin the EU in a future referendum, a new poll has revealed.