Welcome. It sounds like it could be wear in the remote gearchange assembly. If you are a DIY mechanic you could get one from a scrappy, or eBay, and replace yours.
Thanks for your response. It sounds like a good shout. I have changed the discs and the pads myself however I have never tried anything like this, I could potentially lift the car and have a look at underneath or try and strip the middle console and look at the gear change assembly.
Billyaustin, responding to where the noise is coming from; it's difficult to tell, I've always felt that it was coming from the left wheel, last time I had someone in the passenger seat they felt it was more under the footwell/ from the middle of the engine lol. The fact that putting weight on the gear stick stops it seems weird to me.
I have some time off work today so might try to investigate further.
I really appreciate your input !!.