In ’97 the former Yes/King Crimson drummer got together with a couple of jazzers to make one of his most endearing albums, writes GARY STEEL