```
SELECT 
    d.district_id, d.district_name, d1.district_id, d1.district_name
FROM 
    tbl_district d, tbl_district d1 
WHERE
     CASE
        WHEN (d.district_id % 2) != 0 
           THEN d.district_id 
     END
     AND d1.district_id = d.district_id+1;

```