SNP support has slumped during the Holyrood election campaign and the party is on track to fall short of John Swinney's target of a majority, the latest polls have showed.