US president’s comments raise hopes in London of a constructive relationship after past tensions