I don't understand what this has to do with being opposite sex. At which age should an older sister stop sharing her bedroom with a younger sister? Why would the answer differ if it was a younger brother?
For my older kids, the answer was: When their interests were too different from their younger siblings. One of my girls effectively stopped playing at the age of 11, a boy at 12. (They would still play with their younger siblings sometimes, but only to please those, not for her own amusement.) A year or two later they were happy to move into their own room.
FWIW, two of my kids would occasionally share a bed (when visiting elsewhere, when we had visitors, or just because they wanted it for mutual comfort) until they were 11 and 14. Then the older one fell in love with someone, and they stopped.