Speed apparently took his own life just hours after appearing on BBC show Football Focus