Stade Brestois manager Eric Roy has died at 58 following a private battle with pancreatic cancer, leaving behind a legacy of historic European qualification.