Bette Midler has apologised after a tweet she posted about Caitlyn Jenner was deemed transphobic.