Negative Visual for a positive action

I have a warning notification in my software . It asks the user whether they want to proceed or not by providing yes and no buttons in the notification itself. I am thinking of using red font color for YES button and blue font color for NO button.

As shown in the picture below

The reason for using red color for a positive action is that I want the users to feel the negative warmth of this action as once you post this transaction it cannot be reversed.

But my colleague thinks that we should use the colors vice versa as shown below

So what do you guys think about it from the UX perspective?

"Also if you guys agree with my statement , then kindly provide me examples if such sort of negative visual is used for a positive action elsewhere"