Scotland's first minister hopes the US president-elect will be "very different" from how he was on the campaign trail.