A survey by Ipsos also found most Scots dislike the billionaire tech magnate Elon Musk.