Sir John Curtice: Pursuit of Brexit led to surge of independence support