My daughter wore this low backed bra to a recent wedding with a low back dress, and it not only looked great, it was comfortable and stayed in place during over an hour of dancing.
Wacoal is a good quality brand, so as long as you are careful with washing this will last for years.
This one is amazing: b.tempt'd Women's Future Foundation Backless Strapless Bra https://www.amazon.com/dp/B084LMK679?ref=ppx_pop_mob_ap_share