Spikes on the supply line can trip cheap RCD's. Read
this link and you will see not all RCD's are made equal. There are some really expensive RCD's like this

which will auto reset and what we have to decide is how much we are willing to pay? The one in picture costs around £400 and would be used in remote locations where there is no one on site to reset it should it trip due to a spike.
As to cure the first is to select cheap option. I would change the light switch as likely it is arcing a little which is making the spike which in turn is tripping the RCD.