An Indian sexologist, whose candid newspaper column made him an urban legend of sorts, has died aged 96.