Donald Trump’s dream of bringing major tournament back to historic Scottish golf course he owns is over – after organisers resist lobbying from UK Government