SortMergeJoin: Add RightSemi join support #13471

Is your feature request related to a problem or challenge?

Sort Merge Join currently supports LeftSemi join however it would be nice to have RightSemi support as well

https://github.com/apache/datafusion/blob/main/datafusion/physical-plan/src/joins/sort_merge_join.rs

Describe the solution you'd like

Add support unit tests and fuzz tests

Describe alternatives you've considered

No response

Additional context

No response