Celestial bodies order remains unchanged when the Distance setting is modified

How to reproduce:
1. Open the attached “IN-121184_repro” project
2. In the Hierarchy tab, click on the “Sun3” GameObject
3. In the Inspector, in the Light component find the Celestial Body dropdown and change the Distance parameter to 50
4. Observe the Game window

Expected result: The white Celestial body renders on top of the blue and red ones
Actual result: The white Celestial body does not render on top of the blue and red ones

Reproducible with: 2023.3.0a12, 6000.0.60f1 (61dfb374e36f), 6000.2.9f1, 6000.3.0b8, 6000.4.0a3
Could not test with: 2023.1.0a1, 2023.3.0a11 (The Celestial body’s Distance parameter is not available)

Reproducible on: macOS 15.3.2 (24D81) (M1 Max), Windows 11 (10.0.26100) X64 (Tested by the reporter)
Not reproducible on: No other environments tested

Notes:

• Reproducible in Player
• For “Distance” values ≥ 1000000 sorting always works correctly
• With certain “Distance” values, the Celestial Body renders inconsistently: some areas render as expected, while others do not. (See the attached “CelestialBodiesBug“ image)