The former Cardiff City, Liverpool and Celtic man also admitted he nearly hung up his boots at the age of 23