A football club has expressed its sympathies to the family of an avid supporter who died after he was taken ill during a match which saw his team relegated from the Championship.