How to make such query with GROUP BY?

Question

MySQL

Good afternoon!
There is a table in the db:

and a query using GROUP BY:

SELECT id FROM `table` GROUP BY value ORDER BY id DESC

we get:

array(2) {
  [0]=>
  array(1) {
    ["id"]=>
    string(1) "1"
  }
  [1]=>
  array(1) {
    ["id"]=>
    string(1) "3"
  }
}

The question is how to make the result return like this:

array(2) {
  [0]=>
  array(1) {
    ["id"]=>
    string(1) "5"
  }
  [1]=>
  array(1) {
    ["id"]=>
    string(1) "4"
  }
}

Thank you.

Answer 1

SELECT MAX(id) FROM `table` GROUP BY value ORDER BY id ASC

Answer 2

SELECT id FROM (select id, value from `table` ORDER BY id desc) as tbl GROUP BY value

ps if you have something in the ID code attached in this way and it will break from the wrong one, then you probably shouldn't do it. Because the grouping will change at any moment and the IDs there will be different and generally any. In general, it is necessary to somehow think over this more correctly.
pps Option Max is more correct, I forgot this option.