Oh dear what a mess. However it is common, the standard ceiling rose was a junction box with typically 4 connections switched line, permanent line, neutral and a clamp for the earth.
When the ceiling rose is removed it should be replaced with a junction box
which has the same connections, and cable clamps so cables can't be pulled out.
The regulations talk about a key or tool being required with a NOTE: This regulation does not apply to:
a ceiling rose complying with BS 67
a cord operated switch complying with BS 3676
a bayonet lampholder complying with BS EN 61184
an Edison screw lampholder complying with BS EN 60238.
These are allowed to have a cover which you can remove without a tool, the problem lies in that we tend to fit chandeliers from below not above, I use this type
of ceiling rose to take the weight, however all ceiling roses should take 5 kg (559.6.1.5) but personally I would suspect many are screwed into plaster board and would never take that weight, personally holding even 2 kg while making connections I find hard.
However we start by counting the cables.
2 cables likely end of line, so one is supply and one is to switch.
3 cables likely supply in and supply out plus one to switch.
4 cables likely the extra one is either a second supply out or there are two lights in the same room.
It seems likely that brown is a second supply out and should go in the the reds, but without testing that is just a guess.