need help in Query optimization
Create index on (start_ip_number,end_ip_number) and then check the Explain Plan.The query should user this newly created index.

You can also drop index  ind_ipscan (end_ip_number,start_ip_number) if you are not using it some where else.