Eimear McBride had promised her second novel would be full of sex — she wasn’t lying. It’s hard to think of an Irish novel that’s more convincing about female sexuality, or more erotic, writes John P O’Sullivan