By agreeing to meet the US president during his trip to his two Scottish resorts, the prime minister risks not only becoming the focus of the inevitable protests – but also the negative blowback from British public opinion, says Mary Dejevsky