How can I do an orderBy query for data that is stored in JSON format?

So for example when the data is in string format I can do something like this:

->orderBy(DB::raw('FIELD(animal_type, "fish", "amphibian", "reptile", "bird", "mammal", "") ASC, animal_type'))

But if the data for 'animal_type' is stored in JSON format like this:

["vertebrate", "amphibian"]

Let's say I have a table that looks like this:

|id|animal|animal_type|
|--| --- | --- |
|1 |Leaf green tree frog |["vertebrate", "amphibian", "ectothermic", "pelodryadidae"]|
|2 |Seymouria|["vertebrate", "amphibian"]|
|3 |Dermophis mexicanus|["amphibian"]|
|4 |Old World sparrow|["vertebrate", "bird"]|
|5 |Parrot|["vertebrate", "bird", "psittacines"]|
|6 |African bush elephant|["vertebrate", "mammal"]|

Ideally I'd like to sort by a single characteristic of the animal. Say order by "bird", "amphibian". Then the result would look like:

Old World sparrow
Parrot
Leaf green tree frog
Seymouria
Dermophis mexicanus

How would I go about creating a query that can do an orderBy in this kind of scenario?

EDIT: MySQL 8.0 introduces a JSON function that can help: https://dev.mysql.com/doc/refman/8.0/en/json-search-functions.html#operator_member-of

A pure MySQL query would look something like this:

select * from mytable order by 
    'bird' member of(animal_type) desc, 
    'amphibian' member of(animal_type) desc;

How can I do this in the Laravel way?