Ché Walker's Klook's Last Stand combines laughter, love and sex with a brooding sense of tragic inevitability, says Charles Spencer