In his seven-year reign Steve Clarke took Scotland out of the wilderness but could not find the promised land of knockout major championship football, writes Tom English.