Database

[{"_id":ObjectId("654b7348e704b8abba8af17e"),"name":"","email":"","status":"Active"},{"_id":ObjectId("654b6c662f38d9e087086193"),"name":"","email":"","status":"Pending"},{"_id":ObjectId("654b7fbae8392eddee2d1a31"),"name":"","email":"","status":"Pending"},{"_id":ObjectId("653222c20489664953bbaf1a"),"name":"","email":"","status":"Active"},{"_id":ObjectId("653269653bc13f1b96c6c37d"),"name":"","email":"","status":"Active"}]

Query

db.collection.aggregate([{$addFields:{id_you_are_looking_for:{$cond:{if:{$eq:["$_id",ObjectId("653222c20489664953bbaf1a")]},then:0,/** exact match gets lowest value*/else:1}},acc_status_sort:{$cond:{if:{$eq:["$status","Pending"]},then:0,/** status pending gets lowest value*/else:1}}}},{$sort:{id_you_are_looking_for:1,/** first, ascending order sort on exact match*/acc_status_sort:1,/** then, ascending order sort on status*/}},/** remove the extra fields added* comment out this part to see the sorting fields in results*{* $project: {* id_you_are_looking_for: 0,* acc_status_sort: 0* }*}*/])

Result