Gordon Strachan has said that his first match as Scotland manager brought excitement he had never experienced in his long career in football.