Physical settlement is the most commonly used form of settlement.
Physically settled options are those that involve the actual delivery of the underlying security they are based on. The holder of physically settled call options would therefore buy the underlying security if they were exercised, whereas the holder of physically settled put options would sell the underlying security.
Physically settled options tend to be American style, and most stock options are physically settled.
It isn't always immediately obviously when looking at options as they are listed whether they are physically settled or cash settled, so if this aspect is important to you it's well worth checking to be absolutely sure.
In practice whether an option is physically settled or cash settled isn't particularly relevant that often. This is because most traders don’t actually exercise, but rather attempt to make their profits through buying and selling contracts.
Futures Options Settlement Explained - Closing the Gap: Futures Edition
Cash settlement isn't as common as physical settlement, and it's typically used for options contracts based on securities that aren't easily transferred or delivered. For example, contracts based on indices, foreign currencies, and commodities are typically cash settled. Cash settled options are usually European style, which means they are settled automatically at expiration if they are in profit.
Basically, if there's any intrinsic value in contracts at the time of expiration, then that profit is paid to the holder of the contracts at that point.
If the contracts are at the money or out of the money, meaning there is no intrinsic value, then they expire worthless and no money exchanges hands.