Beverley Knight excels in Memphis, a thrilling musical set in Segregation-era America, says Dominic Cavendish