Holyrood’s refusal to give consent to the EU Withdrawal Bill must act as a wake-up call for the prime minister Alistair Carmichael has warned.