The former Middlesbrough FC captain led the club to back-to-back promotions in the late 1980s