Eurythmics star Dave Stewart gave a superfan the surprise of his life after recording his latest music video in his living room