Don't ask me why but I just thought of this goal, and YouTube was good enough to confirm that the goal and the goalscorer weren't just a figment of my imagination.
I had totally forgotten about that red and white Coventry City away kit, though. My memory was still locked on their chocolate delight from the Wallace and Ferguson era.
Sadly, Bodak doesn't have one of the more informative wiki pages but this article which dates from 2005 fills in some of the gaps.