Database

[{id:1,counter:[2,6]},{id:2,counter:[5,10]},{id:3,counter:[1,3]}]

Query

db.collection.aggregate([{"$addFields":{"sorter":{"$arrayElemAt":["$counter",1]}}},{"$sort":{"sorter":-1}},{"$project":{"sorter":0}}])

Result