Transparent GameObjects are not visible behind other transparent GameObjects when "Receive SSR Transparent" material property is enabled

How to reproduce:

1. Open the “Transparency.zip“ project
2. Open the “OutdoorsScene“
3. Select the “TransparentFront“ material (Assets > Materials)
4. Enable the “Receive SSR Transparent“ property in the Inspector
5. Observe the Game view

Expected results: The second GameObject is seen behind the first transparent GameObject
Actual results: The second GameObject is not visible behind the first transparent GameObject

Reproducible in: 2021.3.33f1, 2022.3.15f1, 2023.2.3f1, 2023.3.0a17

Reproduced on: Windows 11 Pro
Not reproduced on: No other environment tested

Note: Also reproducible in the Player