Football star Paul Gascoigne made an emotional appearance at the British Book Awards as his autobiography won a top literary prize.