It’s usually a neon lamp, a kind of gas discharge lamp. It can run on 230V without an extra resistor, which makes it perfect for this use case. As far as I know there are no neon lamps you can use to light your room, but there are small bulbs you can buy on eBay or Amazon.