One of Britain’s most pre-eminent historians on how the capital’s gravitational pull for talent and investment has been regarded as a weakness for the Union