Valid Indian Mobile Numbers

Return the ids of users whose phone is a valid 10 digit Indian mobile number: it starts with 6, 7, 8 or 9 followed by nine more digits. Order by id.

Table schema

Users(id INT PRIMARY KEY, phone VARCHAR(15))

Sample data

id | phone
1 | 9876543210
2 | 5876543210
3 | 987654321
4 | 6000000000