The UK Government will be "pragmatic" and work with Donald Trump to advance Scottish interests, Scotland Office minister Kirsty McNeill has said as the new US president prepares to take office.