Scotland have been relegated to League B after a disaster show at the national stadium