A poll has suggested there is support for the SNP and Scottish Labour to form a coalition government at Holyrood in 2026.