US president’s second state visit to UK ends with show of unity