Find first child page id of page X

I ma looking for a way to find the first child page id when i know the parent page id
i am getting the parent page id by using
$post->post_parent

from this start i need to find the first child page as it is ordered in the db, not based on post id but on the actual page ordering