A majority of Scots would vote to stay in the UK in a fresh independence referendum, new polling indicates.