does these situation occurs in case of multiple writes happening on same key through multiple leader nodes.
And multiple leader scenario is caused due to split brain.
Yes, this situation can happen when there are concurrent writes from multiple writers. For a real example, see Dynamo where it discusses “Vector Clocks and Conflicting Data”: