Ex-Nicola Sturgeon adviser demolishes SNP dream of Scottish independence