More than 70% of Scots have an unfavourable view of US President Donald Trump, a new poll suggests – but young people are more likely to support him.