The SNP will be 'wiped out' at the next general election now that they have 'lost support for independence', says Scottish journalist Alan Cochrane.