The former Runrig star was optimistic the SNP can get it right