There had been much talk of the possibility of a frosty reception when the US president locked eyes with Scotland's first minister.