The Scottish football legend said both of his parents suffered with the condition, which is hereditary