When you use 'listunspent' in the console command of Bitcoin Core you get an output that prints something like this:
[
{
"txid": "redacted",
"vout": 1,
"address": "1address.............................",
"label": "redacted",
"scriptPubKey": "redacted",
"amount": 0.01,
"confirmations": 100,
"spendable": true,
"solvable": true,
"desc": "pkh([redacted/redacted/redacted/0h/0/0]redacted)#redacted",
"parent_descs": [
"pkh(redacted/redacted/1h/0h/0/*)#redacted"
],
"safe": true
},
(...)
]
I was wondering, in which order does it show up? It is definitely not chronological, because I see a recent transaction with 100 confirmations, then a bunch of older transactions with 40k+ confirmations, then a couple recent ones with 100 confirmations or less at the bottom. This is a full node with pruned=0 in testnet4 btw.