Former SNP Cabinet minister warns Nicola Sturgeon against second independence referendum based on Brexit