Donald Trump’s “deep affection” for Scotland should be utilised during his second presidency to encourage economic benefits for the country, a former Scottish secretary has suggested.