Optimistic vs Pessimistic Locking

Let’s say we’re designing a workflow to update user account balances in a banking app, where each transfer involves deducting $100 from one account and adding it to another.

How would you implement this as an SQL transaction, and would you use optimistic or pessimistic locking to handle potential race conditions? Why?