Opposition parties could stage a vote of confidence in the Government next week to prevent no-deal Brexit, a senior SNP MP has said.