The West Brom midfielder fired the Scots ahead in the challenge match after 10 minutes with a drive from outside the box but Theo Walcott levelled before the break.
Kenny Miller shot the Scots back into the lead just after the break before headers from Danny Welbeck and debutant Ricky Lambert gave the Three Lions victory.
Morrison told the media: "It was definitely the highlight of my career.
"I'm lost for words. It will take a few weeks for it to sink in.
"I got it out of my feet and I thought 'I'm going to hit this' and obviously it went in to the back of the net, it was a great feeling.
"Joe Hart is a great keeper and he does save a lot of long shots but it was solid strike and it moved a bit. I am delighted.
"But I would have like a win more than a goal."
Page 2: 23:12
Vancouver Whitecaps striker Miller, who was left out of Scotland's 1-0 World Cup qualifying win in Croatia in June, believes the Scots let themselves down at the two set-pieces after the break which allowed England to grab the win.
The former Rangers and Celtic striker told Press Association Sport: "We gave everything we had. With two goals, you might expect to have something from the game.
"It was disappointing, the two goals we lost in the second half, two set plays, it should be our bread and butter.
"We are normally quite good at that but tonight we let ourselves down and it cost us the game.
"Obviously but it was fantastic to come back and get involved in the national team and to get a goal in a Scotland versus England game at Wembley was a bit of a dream.
"But it would have been far better if it would have been part of a positive result.
"The dream would have been it being the winning goal.
"It was a nice goal, It was a great ball in from big Alan Hutton, I managed to turn and get the shot off and fortunately it went in.
"It was about seeing the game out but the two goals from set plays was disappointing but there are a lot of positives we can take."