Write a query to display the customer id, customer name, guardian name, reference account holders name of the customers who are referenced / referred by the relation 'NEIGHBOUR'(case-sensitive). Display the records sorted in ascending order based on customer id.

Assuming you are using SQL, the query would look something like this:

SELECT customer_id, customer_name, guardian_name, reference_account_holder_name
FROM customers
WHERE reference_relation = 'NEIGHBOUR'
ORDER BY customer_id ASC;

Here's a step-by-step breakdown of the query:

1. SELECT customer_id, customer_name, guardian_name, reference_account_holder_name: This part of the query specifies the columns that you want to display in your result. In this case, you want to display the customer id, customer name, guardian name, and the name of the reference account holder.

2. FROM customers: This part of the query specifies the table from which you want to retrieve data. In this case, you are retrieving data from the 'customers' table.

3. WHERE reference_relation = 'NEIGHBOUR': This is the condition for selecting rows in the table. Only rows where the 'reference_relation' column is 'NEIGHBOUR' will be selected.

4. ORDER BY customer_id ASC: This part of the query sorts the result in ascending order based on the customer id. 'ASC' stands for 'ascending'. If you wanted to sort in descending order, you would use 'DESC' instead.